
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AddPlayer] 
	@Name nvarchar(100) = null,
	@Type nvarchar(20)= 'R'
AS
BEGIN
	INSERT INTO [dbo].[Player] (Name,[Type]) VALUES(@Name,@Type)
END